Tabela SnomedRelationship

Definicja tabeli SnomedRelationship

Name

SnomedRelationship

Code

SnomedRelationship

Comment

Relacje rodzice/dzieci w drzewie SNOMED


Lista kolumn tabeli SnomedRelationship

Name

Code

ID

ID

EffectiveTime

EffectiveTime

Active

Active

ModuleID

ModuleID

SourceID

SourceID

DestinationID

DestinationID

RelationshipGroup

RelationshipGroup

TypeID

TypeID

CharacteristicTypeID

CharacteristicTypeID

ModifierID

ModifierID


Kolumna ID tabeli SnomedRelationship

Definicja kolumny ID tabeli SnomedRelationship

Name

ID

Code

ID

Data Type

VARCHAR2(18)

Mandatory

Yes

Comment

ID relacji rodzice/dzieci w drzewie SNOMED


Kolumna EffectiveTime tabeli SnomedRelationship

Definicja kolumny EffectiveTime tabeli SnomedRelationship

Name

EffectiveTime

Code

EffectiveTime

Data Type

DATE

Mandatory

Yes

Comment

Znacznik czasu aktualnosci rekordu


Kolumna Active tabeli SnomedRelationship

Definicja kolumny Active tabeli SnomedRelationship

Name

Active

Code

Active

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Flaga aktywnosci


Kolumna ModuleID tabeli SnomedRelationship

Definicja kolumny ModuleID tabeli SnomedRelationship

Name

ModuleID

Code

ModuleID

Data Type

VARCHAR2(18)

Mandatory

Yes

Comment

Identyfikator modulu SNOMED


Kolumna SourceID tabeli SnomedRelationship

Definicja kolumny SourceID tabeli SnomedRelationship

Name

SourceID

Code

SourceID

Data Type

VARCHAR2(18)

Mandatory

Yes

Comment

Podrzedny element relacji


Kolumna DestinationID tabeli SnomedRelationship

Definicja kolumny DestinationID tabeli SnomedRelationship

Name

DestinationID

Code

DestinationID

Data Type

VARCHAR2(18)

Mandatory

Yes

Comment

Nadrzedny element relacji


Kolumna RelationshipGroup tabeli SnomedRelationship

Definicja kolumny RelationshipGroup tabeli SnomedRelationship

Name

RelationshipGroup

Code

RelationshipGroup

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Identyfikator grupy relacji


Kolumna TypeID tabeli SnomedRelationship

Definicja kolumny TypeID tabeli SnomedRelationship

Name

TypeID

Code

TypeID

Data Type

VARCHAR2(18)

Mandatory

Yes

Comment

Typ relacji


Kolumna CharacteristicTypeID tabeli SnomedRelationship

Definicja kolumny CharacteristicTypeID tabeli SnomedRelationship

Name

CharacteristicTypeID

Code

CharacteristicTypeID

Data Type

VARCHAR2(18)

Mandatory

Yes

Comment

Rodzaj relacji


Kolumna ModifierID tabeli SnomedRelationship

Definicja kolumny ModifierID tabeli SnomedRelationship

Name

ModifierID

Code

ModifierID

Data Type

VARCHAR2(18)

Mandatory

Yes

Comment

Typ modyfikatora


Lista kluczy tabeli SnomedRelationship

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli SnomedRelationship

Definicja klucza Identifier_1 tabeli SnomedRelationship

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment